<?php
class Subcategorymanager_Data_Getallsubcategories implements Subcategorymanager_Data_Mainable{
    
    private $core_controller_selectdata;
    
    public function __construct() {
        $this->core_controller_selectdata = new Core_Controller_Selectdata;
    }

    public function main(array $variables = null) {
        $variables['query'] = "SELECT subcategory_settings.subcategory_name, subcategory_content_values.subcategory_title, subcategory_meta_values.subcategory_meta_description, subcategory_meta_values.subcategory_meta_keywords FROM subcategory_settings, subcategory_meta_values, subcategory_content_values WHERE subcategory_settings.subcategory_name = subcategory_meta_values.subcategory_name AND subcategory_settings.subcategory_name = subcategory_content_values.subcategory_name AND subcategory_meta_values.subcategory_name = subcategory_content_values.subcategory_name ORDER BY subcategory_content_values.subcategory_title ASC;";
        //echo $variables['query'];
        //die();
        return $this->core_controller_selectdata->main($variables);
    }

}
